USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[PlayersUpdate]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.PlayersUpdate
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 09/03/08
-- Description:	Players Table Update
-- =============================================
CREATE PROCEDURE PlayersUpdate

            @PlayerId varchar(30),
            @LastSeen datetime
	

AS
BEGIN

UPDATE [Players]
SET
           [PlayerId] = @PlayerId
           ,[LastSeen] = @LastSeen
WHERE
			[PlayerId] = @PlayerId
     
END
GO
